If you just upgraded your Oracle version and you see inconsistency in behavior of your old SQL/XML (SQLX) queries, you might want to check if the actual XML structure is still the same. Specifically, there is a problem with XMLAgg alias. The fact is that if you run the same code on Oracle 9 or … Continue reading similar SQL/XML queries do not work the same way across oracle versions